Result of Populated Facts Tables 13

Using SSIS Toolbox, drag

  1. Execute SQL Task
  2. Sequence Container
  3. Inside the Sequence Container, drag Data Flow Task


* Edited each components in the control flow and Data Flow Task

  1. Click on General
  2. Write the SQL Statement
  3. Click Ok


*Edited the First Data Flow Task(Fact_MoviesRating)


*GIF for each Lookup( Connection and Columns)Fact_MoviesRating



*Edited the First Data Flow Task(Fact_MoviesTicketPrice)



*GIF for each Lookup( Connection and Columns)Fact_MoviesTicketPrice




* After Fact Tables have been populated, used the script provided in the zip file to created Foreign Keys Relationships in both of  the Fact tables.

*Results of Populated Fact Tables









Executed SQL Task SSIS

Look Up Transformation SSIS

OLE DB Source SSIS

OLE DB Destination SSIS